Step 1: Downloading Installing Application Express
Install Oracle Application Express by downloading a ZIP file from the Oracle Application Express download page. You can downloads latest version to install Oracle Application Express from below download URL Page, it may contain many APEX version, better to use the latest APEX Version
http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
Unzip downloaded zip file: unzip apex_21.2_en.zip
Change your working directory to apex.
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example:
$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
Full development environment. Run apexins.sql passing the following four arguments in the order shown:
@apexins.sql tablespace_apex tablespace_files tablespace_temp images
Where:
tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
tablespace_files is the name of the tablespace for the Oracle Application Express files user.
tablespace_temp is the name of the temporary tablespace or tablespace group.
images is the virtual directory for Oracle Application Express images. For installations using EPG, /i/ is the required value for the images argument. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.
Example:
@apexins.sql SYSAUX SYSAUX TEMP /i/
Runtime environment. Run apxrtins.sql passing the following arguments in the order shown:
@apxrtins.sql tablespace_apex tablespace_files tablespace_temp images
Where:
tablespace_apex is the name of the tablespace for the Oracle Application Express application user.
tablespace_files is the name of the tablespace for the Oracle Application Express files user.
tablespace_temp is the name of the temporary tablespace or tablespace group.
images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory as /i/.
Example:
@apxrtins.sql SYSAUX SYSAUX TEMP /i/
When Oracle Application Express installs, it creates three new database accounts:
APEX_180200 - The account that owns the Oracle Application Express schema and metadata.
FLOWS_FILES - The account that owns the Oracle Application Express uploaded files.
APEX_PUBLIC_USER - The minimally privileged account is used for Oracle Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql.
If you configured RESTful Web services, then these additional accounts will be created:
APEX_REST_PUBLIC_USER - The account used when invoking RESTful Services definitions stored in Oracle Application Express.
APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.
If you are upgrading from a previous release, then FLOWS_FILES already exists and APEX_PUBLIC_USER is created if it does not already exist.
Step 2: ORDS Installation and Configuration
Verify APEX version using below query
select comp_name, version from dba_registry where comp_id=’APEX’ order by 1;
Download latest version of ORDS ords-21.4.2.062.1806.zip from http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html
Upload file to directory mainly where APEX is installed. then Create new folder like ords and unzip downloaded file inside folder.
Create the APEX_REST_PUBLIC_USER / APEX_LISTENER users and their passwords:
Go to folder /user/home/nizamappsdba/APEX/apex
Login to sqlplus / as sysdba
@apex_rest_config.sql
Enter a password for the APEX_LISTENER user []
Enter a password for the APEX_REST_PUBLIC_USER user []
Go to ords folder i.e. /user/home/nizamappsdba/APEX/ords and run command java -jar ords.war install advanced
Please make a note that latest version required SYS password instead of SYSTEM, please verify below command is working fine from your DB tier server
Example: sqlplus sys/****@dbnode1.nizamappsdba.com:1529/EBSDB as sysdba
If it is giving login denied error then go to $ORACLE_HOME/dbs and run below command
orapwd file=orapwEBSDB password=**** entries=5 force=y
and then retry sqlplus sys/****@dbnode1.nizamappsdba.com:1529/EBSDB as sysdba once you connected successfully please proceed ahead with installation.
Verify ORDS installation by clicking on http://ords.nizamappsdba.com:8080/ords
How to get username, password for login?
Go to APEX installation folder /user/home/nizamappsdba/APEX/apex and run command @apxchpwd.sql from sqlplus / as sysdba
How to Stop/Start ords:
nohup $JAVA_HOME/bin/java -jar ords.war standalone &